Release 10.1A: OpenEdge Data Management:
SQL Reference

SYSTIMESTAMP

Returns the current date and time as a TIMESTAMP value. This function takes no arguments, and the trailing parentheses are optional.

Syntax

SYSTIMESTAMP [ ( ) ]

Example

This example illustrates different formats for SYSDATE, SYSTIME, and SYSTIMESTAMP:

SELECT SYSDATE FROM test; SYSDATE ------- 09/13/2003 1 record selected SELECT SYSTIME FROM test; SYSTIME ------- 14:44:07:000 1 record selected SELECT SYSTIMESTAMP FROM test; SYSTIMESTAMP ------------ 2003-09-13 14:44:15:000 1 record selected

Compatibility

Progress extension